drop proc p280_p006g
go

create procedure p280_p006g
/*
  -----------------------------------------------------------------------
      P280_P006G - Inventory Analysis Report - Insert Audit Trail
  -----------------------------------------------------------------------
*/

/*
    ------  INPUT VARIABLES   ------
*/
   @bpd char(6)   = " " 
 , @epd char(6)   = " "
 , @loc char(3)   = " "
 , @div char(3)   = " " 
 , @dpt char(4)   = " "
 , @typ char(10)  = " "
 , @src char(6)   = " "
 , @stg char(3)   = " "
 , @fop char(6)   = " "
 , @afm char(3)   = " "
 , @srt char(15)  = " "
 , @act char(6)   = " "
 , @dev char(15)  = " "
 , @spc char(8)   = " "
 , @exp char(20)  = "01. None"
 , @ord char(25)  = "01. Category"
 , @grp char(30)  = " "
 , @dvn char(30)  = " "
 , @bus char(30)  = " "
 , @amt decimal(15,2) = 0
 , @glv char(1)   = "V"
 , @prof char(50) = " "
 , @user char(8)  = " "
 , @diff decimal(15) = 0 
as
/*
    ------ INTERNAL VARIABLES ------
*/

begin
insert into t280audit                                
     (a_uid_c         
     ,f_prof_x        
     ,f_fypd1_c      
     ,f_fypd2_c      
     ,f_loc_c         
     ,f_div_c         
     ,f_dpt_c         
     ,f_invtyp_c     
     ,f_syssrc_c     
     ,f_stg_c        
     ,f_fop_c        
     ,f_afm_c        
     ,f_srt_c        
     ,i_nsid_c      
     ,i_spec_c     
     ,f_acct_c     
     ,f_expr_x    
     ,f_ord_x    
     ,f_grp_x   
     ,f_div_x  
     ,f_bu_x    
     ,f_inv_a    
     ,f_glval_i   
     ,db_upd_d     
     ,db_upd_t     
     )
values
 ( @user
 , @prof
 , @bpd 
 , @epd 
 , @loc 
 , @div 
 , @dpt 
 , @typ 
 , @src
 , @stg
 , @fop
 , @afm
 , @srt
 , @dev
 , @spc
 , @act
 , @exp 
 , @ord 
 , @grp 
 , @dvn
 , @bus
 , @amt 
 , @glv 
 , getdate()
 , @diff    
 )
end
           
/************************************************************************
   Return to the calling environment
 ************************************************************************/

return ( 0 )

go
